# -*- coding: utf-8 -*-

#########################################################################
## This scaffolding model makes your app work on Google App Engine too
## File is released under public domain and you can use without limitations
#########################################################################

if not request.env.web2py_runtime_gae:
    ## if NOT running on Google App Engine use SQLite or other DB

    ## db = DAL('sqlite://storage.sqlite')
    db = DAL('mysql://Devs:M2LTest@172.21.101.12/mrbs',ignore_field_case=False, entity_quoting=True)


else:
    ## connect to Google BigTable (optional 'google:datastore://namespace')
    db = DAL('google:datastore')
    ## store sessions and tickets there
    session.connect(request, response, db = db)
    ## or store session in Memcache, Redis, etc.
    ## from gluon.contrib.memdb import MEMDB
    ## from google.appengine.api.memcache import Client
    ## session.connect(request, response, db = MEMDB(Client()))

## by default give a view/generic.extension to all actions from localhost
## none otherwise. a pattern can be 'controller/function.extension'
response.generic_patterns = ['*'] if request.is_local else []

#########################################################################
## Here is sample code if you need for
## - email capabilities
## - authentication (registration, login, logout, ... )
## - authorization (role based authorization)
## - services (xml, csv, json, xmlrpc, jsonrpc, amf, rss)
## - old style crud actions
## (more options discussed in gluon/tools.py)
#########################################################################

from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
auth = Auth(db, hmac_key=Auth.get_or_create_key())
crud, service, plugins = Crud(db), Service(), PluginManager()

## create all tables needed by auth if not custom tables
auth.define_tables()
## configure email
mail=auth.settings.mailer
mail.settings.server = 'logging' or 'smtp.gmail.com:587'
mail.settings.sender = 'you@gmail.com'
mail.settings.login = 'username:password'

## configure auth policy
auth.settings.registration_requires_verification = False
auth.settings.registration_requires_approval = False
auth.settings.reset_password_requires_verification = True

auth.settings.register_next = URL('user', args='login')
auth.settings.login_next = URL('index')
auth.settings.logout_next = URL('index')
auth.settings.profile_next = URL('index')
auth.settings.register_next = URL('user', args='login')
auth.settings.retrieve_username_next = URL('index')
auth.settings.retrieve_password_next = URL('index')
auth.settings.change_password_next = URL('index')
auth.settings.request_reset_password_next = URL('user', args='login')
auth.settings.reset_password_next = URL('user', args='login')
auth.settings.verify_email_next = URL('user', args='login')

# décommenter ce lien pour créer des utilisateurs via le menu register
auth.settings.actions_disabled=['register']

from gluon.tools import Recaptcha
auth.settings.register_captcha = Recaptcha(request, '6LePaekSAAAAAC0yb9sLxwidDdoxdSFG4dcPGDuj', '6LePaekSAAAAADbDqVHazf4wwI655gBrhmYGASCE')
from gluon.tools import Recaptcha

#########################################################################
# Contrôle sur les tentatives de connexion infructueuses
#########################################################################

ip=request.env.remote_addr
nb_tentative_login= cache.ram(ip,lambda:0,None)

#if nb_tentative_login >= 3:
   #auth.settings.login_captcha = Recaptcha(request, '6LePaekSAAAAAC0yb9sLxwidDdoxdSFG4dcPGDuj', '6LePaekSAAAAADbDqVHazf4wwI655gBrhmYGASCE', use_ssl=True)

def tentative_login(form):
    #global num_login_max_attemps
    cache.ram(ip, lambda:nb_tentative_login +1,0)

def login_succes(form,key=ip):
    cache.ram(key,lambda:0,0)

auth.settings.login_onvalidation.append(tentative_login)
auth.settings.login_onaccept.append(login_succes)

#########################################################################





## if you need to use OpenID, Facebook, MySpace, Twitter, Linkedin, etc.
## register with janrain.com, write your domain:api_key in private/janrain.key
from gluon.contrib.login_methods.rpx_account import use_janrain
use_janrain(auth,filename='private/janrain.key')

#########################################################################
## Define your tables below (or better in another model file) for example
##
## >>> db.define_table('mytable',Field('myfield','string'))
##
## Fields can be 'string','text','password','integer','double','boolean'
##       'date','time','datetime','blob','upload', 'reference TABLENAME'
## There is an implicit 'id integer autoincrement' field
## Consult manual for more options, validators, etc.
##
## More API examples for controllers:
##
## >>> db.mytable.insert(myfield='value')
## >>> rows=db(db.mytable.myfield=='value').select(db.mytable.ALL)
## >>> for row in rows: print row.id, row.myfield
#########################################################################


## --------------------------------- DEFINITION DES TABLES APPLICATIVES ------------------------------------------------------------------------------------------#
db.define_table('categorie',Field('nom','string'),Field('admin_email','string'),Field('heureOuverture','integer'),Field('heureOuvertureMinutes','integer'),Field('heureFermeture','integer'),Field('heureFermetureMinutes','integer'))

db.define_table('salle',Field('nom','string'),Field('capacite','integer'),Field('accessible','integer',default=1,comment='Valeur possible 0-non accessible ou 1- accessible'),Field('categorie_id',db.categorie,requires=IS_IN_DB(db,db.categorie.id,'%(nom)s')))

db.define_table('reservation',Field('etat','integer',writable=False,default=1),Field('dateDebut','datetime',writable=False,requires = IS_DATETIME(format=T('%d-%m-%Y %H:%M'),error_message='doit être au format DD-MM-YYYY HH:MM!')),Field('dateFin','datetime',writable=False,requires = IS_DATETIME(format=T('%d-%m-%Y %H:%M'),error_message='doit être au format DD-MM-YYYY HH:MM!')),Field('salle_id',db.salle,writable=False,requires=IS_IN_DB(db,db.salle.id,'%(nom)s')),Field('reservePar',db.auth_user,writable=False,requires=IS_IN_DB(db,db.auth_user.id,'%(first_name)s')))
